declare @style_no nvarchar(20), @price int

select @style_no = '18mx7080'
select @price = 149

update ms_style set price = @price  where style_no = @style_no
update dc_order_dtl set price = @price, org_price = @price  where style_no = @style_no
 